CREATE external TABLE jms_ods.tab_forfeit_config_new(
ID string                     COMMENT  '主键ID'
,FEE_NAME string              COMMENT  '奖罚名称'
,FEE_MENU string              COMMENT '奖罚菜单'
,FEE_START_TIME date          COMMENT  '奖罚启用时间'
,FEE_END_TIME date            COMMENT  '启罚结束时间'
,APPLY_OPERATOR string               COMMENT  '申请业务'
,APPLY_DEPARTMENT string      COMMENT  '申请部门'
,FEE_TYPE decimal(1,0)        COMMENT  '奖罚类型'
,FEE_LEVEL decimal(8,2)       COMMENT  '起罚点'
,FEE_RATE_LEVEL decimal(4,2)  COMMENT  '起罚率值'
,FEE_PER decimal(6,2)         COMMENT  '每单金额起罚点'
,MAXIMUM decimal(12,2)        COMMENT '最高奖罚金额'
,MINIMUM decimal(12,2)        COMMENT  '最低奖罚金额'
,DURATION_date decimal(4,0)   COMMENT   '奖罚持续时间'
,DURATION_UNIT decimal(1,0)   COMMENT  '奖罚持续时间单位(0:天,1:月)'
,CREATE_TIME date             COMMENT  '创建时间'
,CREATE_BY_NAME string        COMMENT '创建人'
,CREATE_BY_CODE string        COMMENT '创建人编码'
,UPdate_TIME date             COMMENT  '更新时间'
,UPdate_BY_NAME string        COMMENT  '更新人'
,UPdate_BY_CODE string        COMMENT  '更新人编码'
,STATUE decimal(1,0)          COMMENT  '状态(0:禁用,1:启用)'
,IS_DELETE decimal(1,0)        COMMENT '状态(0:删除,1:未删除)'
)COMMENT '罚款配置表'
PARTITIONED BY (
  `dt` string COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS parquet
LOCATION
  '/dw/hive/jms_ods.db/external/tab_forfeit_config_new';